package com.woniuxy.carlife.mapper;

import com.woniuxy.carlife.domain.ServiceCategory;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniuxy.carlife.dto.ServiceCategoryDto;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author fx
 * @ClassName:ServiceCategoryMapper
 * @Description: 门店服务类别mapper接口
 * @date 2021/4/6 20:00
 **/

public interface ServiceCategoryMapper extends BaseMapper<ServiceCategory> {

    /**
     * 功能描述〈查询所有类别并分级〉
     * @author:fx
     * @param: @param null: 
     * @return: 
     * @Date 2021/4/12 9:39
     * @throws 
     */
    @Select("SELECT " +
            " service_category_id, " +
            " service_category_name, " +
            " service_category_level, " +
            " service_category_superior, " +
            " category_status " +
            "FROM t_service_category " +
            "WHERE category_status='使用中' ")
    List<ServiceCategoryDto> findServiceCategoryDto();
}
